/**
 * Copyright(C) 2012 Luvina Software Company
 *
 * TblUserDao.java, 28/12/2012, NgocAnh
 */
package net.luvina.manageuser.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import net.luvina.manageuser.dto.UserDetailDto;
import net.luvina.manageuser.hibernate.TblUser;

/**
 * interface TblUser in DAO
 *
 * @author la-pm Ngoc Anh
 *
 */
public interface TblUserDao extends GenericDao<TblUser, Integer> {

    /**
     * get list user in DB
     *
     * @param offset
     * @param limit
     * @param groupId
     * @param fullName
     * @param sortType
     * @param sortByFullName
     * @param sortByCodeLevel
     * @param sortByEndDate
     * @return list<UserDetailDto>
     */
    public List<UserDetailDto> getListUser(int offset, int limit, int groupId,
            String fullName, String sortType, String sortByFullName,
            String sortByCodeLevel, String sortByEndDate);

    public int getTotalRecords(int userGrpId, String userName);
}
